SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `qm_permissions`
-- ----------------------------
DROP TABLE IF EXISTS `qm_permissions`;
CREATE TABLE `qm_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pid` mediumint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_permissions`
-- ----------------------------
BEGIN;
INSERT INTO `qm_permissions` VALUES ('1', 'daskbord', '我的面板', '我的面板权限', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '0'), ('2', 'server', '服务器信息', '服务器信息', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '1'), ('3', 'viewOwnerInfo', '查看个人信息', '查看个人信息', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '1'), ('4', 'editOwnerInfo', '编辑个人信息', '编辑个人信息', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '1'), ('5', 'employ', '就业指南', '就业指南', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '0'), ('6', 'viewEmploy', '查看就业指南', '查看就业指南', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '5'), ('7', 'editEmploy', '编辑就业指南', '编辑就业指南', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '5'), ('8', 'deleteEmploy', '删除就业指南', '删除就业指南', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '5'), ('9', 'viewEmployCategory', '查看就业指南分类', '查看就业指南分类', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '5'), ('10', 'editEmployCategory', '编辑就业指南分类', '编辑就业指南分类', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '5'), ('11', 'deleteEmployCategory', '删除就业指南分类', '删除就业指南分类', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '5'), ('12', 'viewEmployComment', '查看就业指南评论', '查看就业指南评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '5'), ('13', 'editEmployComment', '编辑就业指南评论', '编辑就业指南评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '5'), ('14', 'deleteEmployComment', '删除就业指南评论', '删除就业指南评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '5'), ('15', 'teaches', '充电加油', '充电加油', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '0'), ('16', 'viewTeaches', '查看充电加油', '查看充电加油课程', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('17', 'editTeaches', '编辑充电加油', '编辑充电加油课程', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('18', 'deleteTeaches', '删除充电加油', '删除充电加油课程', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('19', 'viewTeachesCompany', '查看企业专区', '查看充电加油企业专区内训视频', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('20', 'editTeachesCompany', '编辑企业专区', '编辑充电加油企业专区内训视频', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('21', 'delteTeachesCompany', '删除企业专区', '删除充电加油企业专区内训视频', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('22', 'viewTeachesOrganization', '查看推荐机构', '查看充电加油推荐机构', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('23', 'editTeachesOrganization', '编辑推荐机构', '编辑充电加油推荐机构信息', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('24', 'deleteTeachesOrganization', '删除推荐机构', '删除推荐机构信息', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('25', 'viewTeachesCourse', '查看机构课程', '查看机构课程', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('26', 'editTeachesCourse', '编辑机构课程', '编辑机构课程', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('27', 'deleteTeachesCourse', '删除机构课程', '删除机构课程', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('28', 'viewTeachesComment', '查看评论', '查看评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('29', 'editTeachesComment', '编辑评论', '编辑查看评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('30', 'delteTeachesComment', '删除评论', '删除评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '15'), ('31', 'company', '企业招聘', '企业招聘', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '0'), ('32', 'viewCompany', '查看企业', '查看企业', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('33', 'editCompany', '编辑企业', '编辑企业', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('34', 'deleteCompany', '删除企业', '删除企业', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('35', 'viewCompanyUser', '查看企业用户', '查看企业用户', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('36', 'editCompanyUser', '编辑企业用户', '编辑企业用户', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('37', 'delteCompanyUser', '删除企业用户', '删除企业用户', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('38', 'viewCompanyType', '查看行业分类', '查看行业分类', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('39', 'editCompanyType', '编辑行业分类', '编辑行业分类', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('40', 'deleteCompanyType', '删除行业分类', '删除行业分类', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('41', 'viewCompanyPhoto', '查看企业相册', '查看企业相册', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('42', 'editCompanyPhoto', '编辑企业相册', '编辑企业相册', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('43', 'deleteCompanyPhoto', '删除企业相册', '删除企业相册', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('44', 'viewCompanyScale', '查看企业规模', '查看企业规模', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('45', 'editCompanyScale', '编辑企业规模', '编辑企业规模', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('46', 'deleteCompanyScale', '删除企业规模', '删除企业规模', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('47', 'viewCompanyDev', '查看企业发展阶段', '查看企业发展阶段', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('48', 'editCompanyDev', '编辑企业发展阶段', '编辑企业发展阶段', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('49', 'deleteCompanyDev', '删除企业发展阶段', '删除企业发展阶段', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('50', 'viewCompanyJobs', '查看企业职位', '查看企业职位', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('51', 'editCompanyJobs', '编辑企业职位', '编辑企业职位', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('52', 'deleteCompanyJobs', '删除企业职位', '删除企业职位', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('53', 'viewCompanyJobsType', '查看企业职位分类', '查看企业职位分类', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('54', 'editCompanyJobsType', '编辑企业职位分类', '编辑企业职位分类', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('55', 'deleteCompanyJobsType', '删除企业职位分类', '删除企业职位分类', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('56', 'viewCompanyBox', '查看职位投递', '查看职位投递', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('57', 'editCompanyBox', '编辑职位投递', '编辑职位投递', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('58', 'deleteCompanyBox', '删除职位投递', '删除职位投递', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('59', 'viewCompanyComment', '查看评论', '查看评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('60', 'editCompanyComment', '编辑评论', '编辑评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('61', 'deleteCompanyComment', '删除评论', '删除评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('62', 'viewCompanyAuth', '查看企业认证', '查看企业认证', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('63', 'editCompanyAuth', '编辑企业认证', '编辑企业认证', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('64', 'deleteCompanyAuth', '删除企业认证', '删除企业认证', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('65', 'viewExam', '查看考试', '查看考试', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('66', 'editExam', '编辑考试', '编辑考试', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('67', 'deleteExam', '删除考试', '删除考试', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '31'), ('68', 'bbs', '青苜社区', '青苜社区', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '0'), ('69', 'viewBbsCategory', '查看板块', '查看板块', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('70', 'editBbsCategory', '编辑板块', '编辑板块', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('71', 'deleteBbsCategory', '删除板块', '删除板块', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('72', 'viewBbsContent', '查看内容设置', '查看内容设置', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('73', 'editBbsContent', '编辑内容设置', '编辑内容设置', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('74', 'viewBbsPerm', '查看防灌水设置', '查看防灌水设置', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('75', 'editBbsPerm', '编辑防灌水设置', '编辑防灌水设置', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('76', 'viewBbsQuestion', '查看问题', '查看问题', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('77', 'editBbsQuestion', '编辑问题', '编辑问题', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('78', 'deleteBbsQuestion', '删除问题', '删除问题', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('79', 'viewBbsAnswer', '查看回答', '查看回答', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('80', 'editBbsAnswer', '编辑回答', '编辑回答', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('81', 'deleteBbsAnswer', '删除回答', '删除回答', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('82', 'viewBbsComment', '查看评论', '查看评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('83', 'editBbsComment', '编辑评论', '编辑评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('84', 'deleteBbsComment', '删除评论', '删除评论', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '68'), ('85', 'content', '内容设置', '内容设置', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '0'), ('86', 'viewContent', '查看基本信息', '查看基本信息', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('87', 'editContent', '编辑基本信息', '编辑基本信息', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('88', 'viewContentBanner', '查看首页轮播', '查看首页轮播', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('89', 'editContentBanner', '编辑首页轮播', '编辑首页轮播', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('90', 'deleteContentBanner', '删除首页轮播', '删除首页轮播', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('91', 'viewContentModule', '查看模块介绍', '查看模块介绍', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('92', 'editContentModule', '编辑模块介绍', '编辑模块介绍', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('93', 'deleteContentModule', '删除模块介绍', '删除模块介绍', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('94', 'viewContentRecommend', '查看热门推荐', '查看热门推荐', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('95', 'editContentRecommend', '编辑热门推荐', '编辑热门推荐', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('96', 'deleteContentRecommend', '删除热门推荐', '删除热门推荐', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('97', 'viewContentLink', '查看友情链接', '查看友情链接', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('98', 'editContentLink', '编辑友情链接', '编辑友情链接', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('99', 'deleteContentLink', '删除友情链接', '删除友情链接', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('100', 'viewContentArea', '查看地区管理', '查看地区管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('101', 'editContentArea', '编辑地区管理', '编辑地区管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('102', 'deleteContenArea', '删除地区管理', '删除地区管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('103', 'viewContentAds', '查看广告', '查看广告', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('104', 'editContentAds', '编辑广告', '编辑广告', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('105', 'deleteContentAds', '删除广告', '删除广告', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('106', 'viewContentPosition', '查看投放位', '查看投放位', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('107', 'editContentPosition', '编辑投放位', '编辑投放', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('108', 'deleteContentPosition', '删除投放位', '删除投放位', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '85'), ('109', 'user', '用户管理', '用户管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '0'), ('110', 'viewUser', '查看用户', '查看用户', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('111', 'editUser', '编辑用户', '编辑用户', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('112', 'deleteUser', '删除用户', '删除用户', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('113', 'viewUserCharge', '查看充值记录', '查看充值记录', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('114', 'editUserCharge', '编辑充值记录', '编辑充值记录', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('115', 'deleteUserCharge', '删除充值记录', '删除充值记录', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('116', 'viewUserConsume', '查看积分消费', '查看积分消费', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('117', 'editUserConsume', '编辑积分消费', '编辑积分消费', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('118', 'deleteUserConsume', '删除积分消费', '删除积分消费', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('119', 'viewUserPoint', '查看积分新增', '查看积分新增', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('120', 'editUserPoint', '编辑积分新增', '编辑积分新增', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('121', 'deleteUserPoint', '删除积分新增', '删除积分新增', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('122', 'viewUserResume', '查看用户简历', '查看用户简历', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('123', 'editUserResume', '编辑用户简历', '编辑用户简历', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('124', 'deleteUserResume', '删除用户简历', '删除用户简历', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('125', 'viewUserResumeStatus', '查看简历状态', '查看简历状态', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('126', 'editUserResumeStatus', '编辑简历状态', '编辑简历状态', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('127', 'deleteUserResumeStatus', '删除简历状态', '删除简历状态', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('128', 'viewUserGroup', '查看会员组', '查看会员组', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('129', 'editUserGroup', '编辑会员组', '编辑会员组', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('130', 'deleteUserGroup', '删除会员组', '删除会员组', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('131', 'viewUserPermission', '查看权限管理', '查看权限管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('132', 'editUserPermission', '编辑权限管理', '编辑权限管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('133', 'deleteUserPermission', '删除权限管理', '删除权限管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('134', 'viewUserMsg', '查看用户私信', '查看用户私信', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('135', 'editUserMsg', '编辑用户私信', '编辑用户私信', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('136', 'deleteUserMsg', '删除用户私信', '删除用户私信', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('137', 'viewUserReport', '查看举报管理', '查看举报管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('138', 'editUserReport', '编辑举报管理', '编辑举报管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('139', 'deleteUserReport', '删除举报管理', '删除举报管理', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '109'), ('140', 'setting', '系统设置', '系统设置', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '0'), ('141', 'viewSettingAdmin', '查看管理员', '查看管理员', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '140'), ('142', 'editSettingAdmin', '编辑管理员', '编辑管理也员', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '140'), ('143', 'deleteSettingAdmin', '删除管理员', '删除管理员', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '140'), ('144', 'viewSettingRole', '查看角色', '查看角色', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '140'), ('145', 'editSettingRole', '编辑角色', '编辑角色', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '140'), ('146', 'deleteSettingRole', '删除角色', '删除角色', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '140'), ('147', 'viewSettingMenu', '查看后台菜单', '查看后台菜单', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '140'), ('148', 'editSettingMenu', '编辑后台菜单', '编辑后台菜单', '2015-11-20 10:26:50', '2015-11-20 10:26:50', '140');
COMMIT;

-- ----------------------------
--  Table structure for `qm_permission_role`
-- ----------------------------
DROP TABLE IF EXISTS `qm_permission_role`;
CREATE TABLE `qm_permission_role` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `qm_permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `qm_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_permission_role`
-- ----------------------------
BEGIN;
INSERT INTO `qm_permission_role` VALUES ('1', '1'), ('2', '1'), ('3', '1'), ('4', '1'), ('5', '1'), ('6', '1'), ('7', '1'), ('8', '1'), ('9', '1'), ('10', '1'), ('11', '1'), ('12', '1'), ('13', '1'), ('14', '1'), ('15', '1'), ('16', '1'), ('17', '1'), ('18', '1'), ('19', '1'), ('20', '1'), ('21', '1'), ('22', '1'), ('23', '1'), ('24', '1'), ('25', '1'), ('26', '1'), ('27', '1'), ('28', '1'), ('29', '1'), ('30', '1'), ('31', '1'), ('32', '1'), ('33', '1'), ('34', '1'), ('35', '1'), ('36', '1'), ('37', '1'), ('38', '1'), ('39', '1'), ('40', '1'), ('41', '1'), ('42', '1'), ('43', '1'), ('44', '1'), ('45', '1'), ('46', '1'), ('47', '1'), ('48', '1'), ('49', '1'), ('50', '1'), ('51', '1'), ('52', '1'), ('53', '1'), ('54', '1'), ('55', '1'), ('56', '1'), ('57', '1'), ('58', '1'), ('59', '1'), ('60', '1'), ('61', '1'), ('62', '1'), ('63', '1'), ('64', '1'), ('65', '1'), ('66', '1'), ('67', '1'), ('68', '1'), ('69', '1'), ('70', '1'), ('71', '1'), ('72', '1'), ('73', '1'), ('74', '1'), ('75', '1'), ('76', '1'), ('77', '1'), ('78', '1'), ('79', '1'), ('80', '1'), ('81', '1'), ('82', '1'), ('83', '1'), ('84', '1'), ('85', '1'), ('86', '1'), ('87', '1'), ('88', '1'), ('89', '1'), ('90', '1'), ('91', '1'), ('92', '1'), ('93', '1'), ('94', '1'), ('95', '1'), ('96', '1'), ('97', '1'), ('98', '1'), ('99', '1'), ('100', '1'), ('101', '1'), ('102', '1'), ('103', '1'), ('104', '1'), ('105', '1'), ('106', '1'), ('107', '1'), ('108', '1'), ('109', '1'), ('110', '1'), ('111', '1'), ('112', '1'), ('113', '1'), ('114', '1'), ('115', '1'), ('116', '1'), ('117', '1'), ('118', '1'), ('119', '1'), ('120', '1'), ('121', '1'), ('122', '1'), ('123', '1'), ('124', '1'), ('125', '1'), ('126', '1'), ('127', '1'), ('128', '1'), ('129', '1'), ('130', '1'), ('131', '1'), ('132', '1'), ('133', '1'), ('134', '1'), ('135', '1'), ('136', '1'), ('137', '1'), ('138', '1'), ('139', '1'), ('140', '1'), ('141', '1'), ('142', '1'), ('143', '1'), ('144', '1'), ('145', '1'), ('146', '1'), ('147', '1'), ('148', '1'), ('1', '2'), ('2', '2'), ('3', '2'), ('4', '2'), ('5', '2'), ('6', '2'), ('7', '2'), ('8', '2'), ('9', '2'), ('10', '2'), ('11', '2'), ('12', '2'), ('13', '2'), ('14', '2');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
